﻿-- =============================================
-- Script Template
-- =============================================

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/****Create Default Records ****/
PRINT 'INSERTING DEFAULT DATA .... [Sys_ActivityMaster]'
GO

SET IDENTITY_INSERT [Sys_ActivityMaster] ON
INSERT [Sys_ActivityMaster] ([ActivityKey], [ActivityCode], [ActivityName], [ActivityDescription], [ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, N'DFLT_BLG_CRT', N'Create Default Blogs', N'Can Create Default Blogs', 1, N'CRT', N'CREATE', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_ActivityMaster] ([ActivityKey], [ActivityCode], [ActivityName], [ActivityDescription], [ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, N'DFLT_BLG_RTV', N'Retrieve Default Blog', N'Can Retrieve Default Blog', 2, N'RTV', N'RETRIEVE', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_ActivityMaster] ([ActivityKey], [ActivityCode], [ActivityName], [ActivityDescription], [ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, N'DFLT_BLG_UPD', N'Update Default Blogs', N'Can Update Default Blogs ', 3, N'UPD', N'UPDATE', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_ActivityMaster] ([ActivityKey], [ActivityCode], [ActivityName], [ActivityDescription], [ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, N'DFLT_BLG_DEL', N'Delete Default Blog', N'Can Delete Default Blog', 4, N'DEL', N'DELETE', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_ActivityMaster] ([ActivityKey], [ActivityCode], [ActivityName], [ActivityDescription], [ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, N'DFLT_DNL_CRT', N'Create Default Downloadable Content', N'Can Create Default Downloadable Content', 1, N'CRT', N'CREATE', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_ActivityMaster] ([ActivityKey], [ActivityCode], [ActivityName], [ActivityDescription], [ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, N'DFLT_DNL_RTV', N'Retrieve Default Downloadable Content', N'Can Retrieve Default Downloadable Content', 2, N'RTV', N'RETRIEVE', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_ActivityMaster] ([ActivityKey], [ActivityCode], [ActivityName], [ActivityDescription], [ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, N'DFLT_DNL_UPD', N'Update Default Downloadable Contents', N'Can Update Default Downloadable Contents', 3, N'UPD', N'UPDATE', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_ActivityMaster] ([ActivityKey], [ActivityCode], [ActivityName], [ActivityDescription], [ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, N'DFLT_DNL_DEL', N'Delete Default Downloadable Content', N'Can Delete Default Downloadable Content', 4, N'DEL', N'DELETE', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_ActivityMaster] ([ActivityKey], [ActivityCode], [ActivityName], [ActivityDescription], [ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (9, N'BLG_CRT', N'Create Blogs', N'Can Create Blogs except Default Blog', 1, N'CRT', N'CREATE', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_ActivityMaster] ([ActivityKey], [ActivityCode], [ActivityName], [ActivityDescription], [ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (10, N'BLG_RTV', N'Retrieve Blogs', N'Can Retrieve Blogs including Default Blog', 2, N'RTV', N'RETRIEVE', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_ActivityMaster] ([ActivityKey], [ActivityCode], [ActivityName], [ActivityDescription], [ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (11, N'BLG_UPD_OWN', N'Update Self-created  Blogs', N'Can Update Blogs created by self', 3, N'UPD', N'UPDATE', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_ActivityMaster] ([ActivityKey], [ActivityCode], [ActivityName], [ActivityDescription], [ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (12, N'BLG_DEL_OWN', N'Delete Self-created Blogs', N'Can Delete Blogs created by self', 4, N'DEL', N'DELETE', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_ActivityMaster] ([ActivityKey], [ActivityCode], [ActivityName], [ActivityDescription], [ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (13, N'DNL_CRT', N'Create Downloadable Content', N'Can Create Downloadable Content  except Default Downloadable Content', 1, N'CRT', N'CREATE', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_ActivityMaster] ([ActivityKey], [ActivityCode], [ActivityName], [ActivityDescription], [ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (14, N'DNL_RTV', N'Retrieve Downloadable Contents', N'Can Retrieve Downloadable Content including Default Downloadable Content', 2, N'RTV', N'RETRIEVE', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_ActivityMaster] ([ActivityKey], [ActivityCode], [ActivityName], [ActivityDescription], [ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (15, N'DNL_UPD_OWN', N'Update Self-created Downloadable Contents', N'Can Update Downloadable Contents  created by self', 3, N'UPD', N'UPDATE', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_ActivityMaster] ([ActivityKey], [ActivityCode], [ActivityName], [ActivityDescription], [ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (16, N'DNL_DEL_OWN', N'Delete Self-created Downloadable Contents', N'Can Delete Downloadable Contents created by self', 4, N'DEL', N'DELETE', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
SET IDENTITY_INSERT [Sys_ActivityMaster] OFF